﻿using System;
using System.Collections.Generic;

using System.Text;
using Fodee.DataEntity;
using System.Data.SqlClient;

namespace Fodee.DataAccess
{
    public class StaffDA : DataAccess
    {
        public FodeeDataSet SearchStaff(string SearchCondition, int deptID)
        {
            DataBase database = new DataBase();
            SqlParameter param = new SqlParameter("@Condition", SearchCondition);
            SqlParameter param1 = new SqlParameter("@DeptID", deptID);
            FodeeDataSet ds = new FodeeDataSet();
            database.ExcuteQuery("[P_fod_Staff_S_By_NameOrCodeOrNumAndDept]", ds.fod_Staff, new SqlParameter[] { param,param1 });
            return ds;
        }
    }
}
